﻿/*
#------------------------------------------------------------------------------
#-- Program Name:	[dbo].[spIsEnterpriseSQL]
#-- Purpose:		Determines if the installed SQL Server instance is at
#--					least Enterprise Edition level.
#--	Last Update:	08/29/2011
#--					For a complete history - please review comments in Version
#--					control.
#------------------------------------------------------------------------------
*/
CREATE PROCEDURE [dbo].[spIsEnterpriseSQL]
AS
BEGIN
	--- Return the Answer to the Question
	RETURN	CAST(CASE WHEN SERVERPROPERTY('EngineEdition') = 3 THEN 1 ELSE 0 END as bit)
END
